Overview

Brought to you by YData

Dataset statistics

Number of variables	23
Number of observations	10000
Missing cells	2975
Missing cells (%)	1.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	7.1 MiB
Average record size in memory	746.3 B

Variable types

Numeric	16
Text	4
Categorical	1
URL	2

Alerts

`best_book_id` is highly overall correlated with `goodreads_book_id` and 2 other fields	High correlation
`book_id` is highly overall correlated with `ratings_1` and 7 other fields	High correlation
`books_count` is highly overall correlated with `ratings_3`	High correlation
`goodreads_book_id` is highly overall correlated with `best_book_id` and 2 other fields	High correlation
`original_publication_year` is highly overall correlated with `best_book_id` and 2 other fields	High correlation
`ratings_1` is highly overall correlated with `book_id` and 7 other fields	High correlation
`ratings_2` is highly overall correlated with `book_id` and 7 other fields	High correlation
`ratings_3` is highly overall correlated with `book_id` and 8 other fields	High correlation
`ratings_4` is highly overall correlated with `book_id` and 7 other fields	High correlation
`ratings_5` is highly overall correlated with `book_id` and 7 other fields	High correlation
`ratings_count` is highly overall correlated with `book_id` and 7 other fields	High correlation
`work_id` is highly overall correlated with `best_book_id` and 2 other fields	High correlation
`work_ratings_count` is highly overall correlated with `book_id` and 7 other fields	High correlation
`work_text_reviews_count` is highly overall correlated with `book_id` and 7 other fields	High correlation
`language_code` is highly imbalanced (73.7%)	Imbalance
`isbn` has 700 (7.0%) missing values	Missing
`isbn13` has 585 (5.9%) missing values	Missing
`original_title` has 585 (5.9%) missing values	Missing
`language_code` has 1084 (10.8%) missing values	Missing
`ratings_1` is highly skewed (γ1 = 37.71159779)	Skewed
`book_id` is uniformly distributed	Uniform
`book_id` has unique values	Unique
`goodreads_book_id` has unique values	Unique
`best_book_id` has unique values	Unique
`work_id` has unique values	Unique

Reproduction

Analysis started	2024-12-11 17:24:57.545629
Analysis finished	2024-12-11 17:25:37.580847
Duration	40.04 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

book_id
Real number (ℝ)

High correlation Uniform Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5000.5

Minimum	1
Maximum	10000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	500.95
Q1	2500.75
median	5000.5
Q3	7500.25
95-th percentile	9500.05
Maximum	10000
Range	9999
Interquartile range (IQR)	4999.5

Descriptive statistics

Standard deviation	2886.8957
Coefficient of variation (CV)	0.5773214
Kurtosis	-1.2
Mean	5000.5
Median Absolute Deviation (MAD)	2500
Skewness	0
Sum	50005000
Variance	8334166.7
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
Other values (9990)	9990	99.9%

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
10000	1	< 0.1%
9999	1	< 0.1%
9998	1	< 0.1%
9997	1	< 0.1%
9996	1	< 0.1%
9995	1	< 0.1%
9994	1	< 0.1%
9993	1	< 0.1%
9992	1	< 0.1%
9991	1	< 0.1%

goodreads_book_id
Real number (ℝ)

High correlation Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5264696.5

Minimum	1
Maximum	33288638
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	5804.6
Q1	46275.75
median	394965.5
Q3	9382225.2
95-th percentile	22055280
Maximum	33288638
Range	33288637
Interquartile range (IQR)	9335949.5

Descriptive statistics

Standard deviation	7575461.9
Coefficient of variation (CV)	1.4389171
Kurtosis	0.68873226
Mean	5264696.5
Median Absolute Deviation (MAD)	388295
Skewness	1.3452531
Sum	5.2646965 × 10¹⁰
Variance	5.7387622 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8914	1	< 0.1%
2767052	1	< 0.1%
3	1	< 0.1%
41865	1	< 0.1%
2657	1	< 0.1%
4671	1	< 0.1%
11870085	1	< 0.1%
5907	1	< 0.1%
5107	1	< 0.1%
960	1	< 0.1%
Other values (9990)	9990	99.9%

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
13	1	< 0.1%
21	1	< 0.1%

Value	Count	Frequency (%)
33288638	1	< 0.1%
32848471	1	< 0.1%
32075671	1	< 0.1%
31845516	1	< 0.1%
31538647	1	< 0.1%
31538635	1	< 0.1%
31538614	1	< 0.1%
31194270	1	< 0.1%
31176886	1	< 0.1%
31140847	1	< 0.1%

best_book_id
Real number (ℝ)

High correlation Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5471213.6

Minimum	1
Maximum	35534230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	5935.8
Q1	47911.75
median	425123.5
Q3	9636112.5
95-th percentile	22816426
Maximum	35534230
Range	35534229
Interquartile range (IQR)	9588200.8

Descriptive statistics

Standard deviation	7827329.9
Coefficient of variation (CV)	1.4306387
Kurtosis	0.7464968
Mean	5471213.6
Median Absolute Deviation (MAD)	418042
Skewness	1.3503132
Sum	5.4712136 × 10¹⁰
Variance	6.1267093 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8914	1	< 0.1%
2767052	1	< 0.1%
3	1	< 0.1%
41865	1	< 0.1%
2657	1	< 0.1%
4671	1	< 0.1%
11870085	1	< 0.1%
5907	1	< 0.1%
5107	1	< 0.1%
960	1	< 0.1%
Other values (9990)	9990	99.9%

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
13	1	< 0.1%
21	1	< 0.1%
24	1	< 0.1%

Value	Count	Frequency (%)
35534230	1	< 0.1%
35534215	1	< 0.1%
35036409	1	< 0.1%
34371311	1	< 0.1%
34324605	1	< 0.1%
33602148	1	< 0.1%
33586715	1	< 0.1%
33396914	1	< 0.1%
33393313	1	< 0.1%
33290408	1	< 0.1%

work_id
Real number (ℝ)

High correlation Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8646183.4

Minimum	87
Maximum	56399597
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	87
5-th percentile	58190.6
Q1	1008841
median	2719524.5
Q3	14517748
95-th percentile	40852955
Maximum	56399597
Range	56399510
Interquartile range (IQR)	13508907

Descriptive statistics

Standard deviation	11751061
Coefficient of variation (CV)	1.3591038
Kurtosis	2.4941074
Mean	8646183.4
Median Absolute Deviation (MAD)	2394770.5
Skewness	1.7630534
Sum	8.6461834 × 10¹⁰
Variance	1.3808743 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11817	1	< 0.1%
2792775	1	< 0.1%
4640799	1	< 0.1%
3212258	1	< 0.1%
3275794	1	< 0.1%
245494	1	< 0.1%
16827462	1	< 0.1%
1540236	1	< 0.1%
3036731	1	< 0.1%
3338963	1	< 0.1%
Other values (9990)	9990	99.9%

Value	Count	Frequency (%)
87	1	< 0.1%
98	1	< 0.1%
104	1	< 0.1%
114	1	< 0.1%
115	1	< 0.1%
141	1	< 0.1%
362	1	< 0.1%
387	1	< 0.1%
423	1	< 0.1%
434	1	< 0.1%

Value	Count	Frequency (%)
56399597	1	< 0.1%
55548884	1	< 0.1%
55483783	1	< 0.1%
54007532	1	< 0.1%
53450421	1	< 0.1%
53292620	1	< 0.1%
52885176	1	< 0.1%
52218770	1	< 0.1%
52218734	1	< 0.1%
51814255	1	< 0.1%

books_count
Real number (ℝ)

High correlation

Distinct	597
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	75.7127

Minimum	1
Maximum	3455
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	23
median	40
Q3	67
95-th percentile	215.05
Maximum	3455
Range	3454
Interquartile range (IQR)	44

Descriptive statistics

Standard deviation	170.47073
Coefficient of variation (CV)	2.2515473
Kurtosis	95.303049
Mean	75.7127
Median Absolute Deviation (MAD)	20
Skewness	8.4100916
Sum	757127
Variance	29060.269
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25	186	1.9%
24	174	1.7%
18	163	1.6%
20	162	1.6%
30	161	1.6%
33	157	1.6%
27	157	1.6%
37	157	1.6%
19	154	1.5%
14	153	1.5%
Other values (587)	8376	83.8%

Value	Count	Frequency (%)
1	39	0.4%
2	53	0.5%
3	42	0.4%
4	49	0.5%
5	71	0.7%
6	83	0.8%
7	88	0.9%
8	92	0.9%
9	94	0.9%
10	107	1.1%

Value	Count	Frequency (%)
3455	1	< 0.1%
3296	1	< 0.1%
2618	1	< 0.1%
2573	1	< 0.1%
2568	1	< 0.1%
2498	1	< 0.1%
2448	1	< 0.1%
2380	1	< 0.1%
2303	1	< 0.1%
2277	1	< 0.1%

isbn
Text

Missing

Distinct	9300
Distinct (%)	100.0%
Missing	700
Missing (%)	7.0%
Memory size	622.9 KiB

Length

Max length	10
Median length	9
Mean length	9.1676344
Min length	7

Characters and Unicode

Total characters	85259
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9300 ?
Unique (%)	100.0%

Sample

1st row	439023483
2nd row	439554934
3rd row	316015849
4th row	61120081
5th row	743273567

Value	Count	Frequency (%)
439023483	1	< 0.1%
439554934	1	< 0.1%
316015849	1	< 0.1%
61120081	1	< 0.1%
743273567	1	< 0.1%
525478817	1	< 0.1%
618260307	1	< 0.1%
316769177	1	< 0.1%
1416524797	1	< 0.1%
679783261	1	< 0.1%
Other values (9290)	9290	99.9%

Most occurring characters

Value	Count	Frequency (%)
1	10582	12.4%
4	9942	11.7%
5	9363	11.0%
3	9036	10.6%
0	8916	10.5%
6	7835	9.2%
2	7805	9.2%
7	7381	8.7%
8	6847	8.0%
9	6738	7.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	85259	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	10582	12.4%
4	9942	11.7%
5	9363	11.0%
3	9036	10.6%
0	8916	10.5%
6	7835	9.2%
2	7805	9.2%
7	7381	8.7%
8	6847	8.0%
9	6738	7.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	85259	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	10582	12.4%
4	9942	11.7%
5	9363	11.0%
3	9036	10.6%
0	8916	10.5%
6	7835	9.2%
2	7805	9.2%
7	7381	8.7%
8	6847	8.0%
9	6738	7.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	85259	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	10582	12.4%
4	9942	11.7%
5	9363	11.0%
3	9036	10.6%
0	8916	10.5%
6	7835	9.2%
2	7805	9.2%
7	7381	8.7%
8	6847	8.0%
9	6738	7.9%

isbn13
Real number (ℝ)

Missing

Distinct	9153
Distinct (%)	97.2%
Missing	585
Missing (%)	5.9%
Infinite	0
Infinite (%)	0.0%
Mean	9.7550443 × 10¹²

Minimum	1.9517034 × 10⁸
Maximum	9.7900077 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1.9517034 × 10⁸
5-th percentile	9.7800609 × 10¹²
Q1	9.7803162 × 10¹²
median	9.7804515 × 10¹²
Q3	9.7808308 × 10¹²
95-th percentile	9.7816114 × 10¹²
Maximum	9.7900077 × 10¹²
Range	9.7898125 × 10¹²
Interquartile range (IQR)	5.1458418 × 10⁸

Descriptive statistics

Standard deviation	4.4286192 × 10¹¹
Coefficient of variation (CV)	0.045398248
Kurtosis	323.64113
Mean	9.7550443 × 10¹²
Median Absolute Deviation (MAD)	2.9551778 × 10⁸
Skewness	-17.762289
Sum	9.1843742 × 10¹⁶
Variance	1.9612668 × 10²³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.780061783 × 10¹²	2	< 0.1%
9.780385342 × 10¹²	2	< 0.1%
9.780983213 × 10¹²	2	< 0.1%
9.78054506 × 10¹²	2	< 0.1%
9.780394758 × 10¹²	2	< 0.1%
9.780061714 × 10¹²	2	< 0.1%
9.780670026 × 10¹²	2	< 0.1%
9.780312625 × 10¹²	2	< 0.1%
9.78006444 × 10¹²	2	< 0.1%
9.78067972 × 10¹²	2	< 0.1%
Other values (9143)	9395	94.0%
(Missing)	585	5.9%

Value	Count	Frequency (%)
195170342	1	< 0.1%
2.598624752 × 10¹⁰	1	< 0.1%
3.180901474 × 10¹⁰	1	< 0.1%
7.678360942 × 10¹⁰	1	< 0.1%
9.789380659 × 10¹⁰	1	< 0.1%
6.308096811 × 10¹¹	1	< 0.1%
6.355170805 × 10¹¹	1	< 0.1%
6.45573003 × 10¹¹	1	< 0.1%
1.230000006 × 10¹²	1	< 0.1%
2.940011081 × 10¹²	1	< 0.1%

Value	Count	Frequency (%)
9.790007672 × 10¹²	1	< 0.1%
9.789993912 × 10¹²	1	< 0.1%
9.789992196 × 10¹²	1	< 0.1%
9.789992196 × 10¹²	1	< 0.1%
9.789992196 × 10¹²	1	< 0.1%
9.789991374 × 10¹²	1	< 0.1%
9.789953891 × 10¹²	1	< 0.1%
9.789953891 × 10¹²	1	< 0.1%
9.789953891 × 10¹²	1	< 0.1%
9.789953891 × 10¹²	1	< 0.1%

authors
Text

Distinct	4664
Distinct (%)	46.6%
Missing	0
Missing (%)	0.0%
Memory size	761.5 KiB

Length

Max length	742
Median length	307
Mean length	18.5215
Min length	3

Characters and Unicode

Total characters	185215
Distinct characters	233
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3321 ?
Unique (%)	33.2%

Sample

1st row	Suzanne Collins
2nd row	J.K. Rowling, Mary GrandPré
3rd row	Stephenie Meyer
4th row	Harper Lee
5th row	F. Scott Fitzgerald

Value	Count	Frequency (%)
john	302	1.1%
james	251	0.9%
david	229	0.8%
robert	193	0.7%
michael	193	0.7%
stephen	165	0.6%
richard	132	0.5%
king	112	0.4%
william	108	0.4%
anne	105	0.4%
Other values (6357)	26432	93.7%

Most occurring characters

Value	Count	Frequency (%)
	18518	10.0%
e	16160	8.7%
a	15524	8.4%
n	12653	6.8%
r	12128	6.5%
i	10774	5.8%
o	9085	4.9%
l	8578	4.6%
s	6475	3.5%
t	6471	3.5%
Other values (223)	68849	37.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	185215	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	18518	10.0%
e	16160	8.7%
a	15524	8.4%
n	12653	6.8%
r	12128	6.5%
i	10774	5.8%
o	9085	4.9%
l	8578	4.6%
s	6475	3.5%
t	6471	3.5%
Other values (223)	68849	37.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	185215	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	18518	10.0%
e	16160	8.7%
a	15524	8.4%
n	12653	6.8%
r	12128	6.5%
i	10774	5.8%
o	9085	4.9%
l	8578	4.6%
s	6475	3.5%
t	6471	3.5%
Other values (223)	68849	37.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	185215	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	18518	10.0%
e	16160	8.7%
a	15524	8.4%
n	12653	6.8%
r	12128	6.5%
i	10774	5.8%
o	9085	4.9%
l	8578	4.6%
s	6475	3.5%
t	6471	3.5%
Other values (223)	68849	37.2%

original_publication_year
Real number (ℝ)

High correlation

Distinct	293
Distinct (%)	2.9%
Missing	21
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	1981.9877

Minimum	-1750
Maximum	2017
Zeros	0
Zeros (%)	0.0%
Negative	31
Negative (%)	0.3%
Memory size	78.2 KiB

Quantile statistics

Minimum	-1750
5-th percentile	1922
Q1	1990
median	2004
Q3	2011
95-th percentile	2015
Maximum	2017
Range	3767
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	152.57667
Coefficient of variation (CV)	0.076981642
Kurtosis	240.59653
Mean	1981.9877
Median Absolute Deviation (MAD)	8
Skewness	-14.755244
Sum	19778255
Variance	23279.639
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2012	568	5.7%
2011	556	5.6%
2013	518	5.2%
2010	473	4.7%
2014	437	4.4%
2009	432	4.3%
2008	383	3.8%
2007	363	3.6%
2006	362	3.6%
2005	326	3.3%
Other values (283)	5561	55.6%

Value	Count	Frequency (%)
-1750	1	< 0.1%
-762	1	< 0.1%
-750	2	< 0.1%
-720	1	< 0.1%
-560	1	< 0.1%
-500	3	< 0.1%
-476	1	< 0.1%
-458	2	< 0.1%
-441	1	< 0.1%
-440	1	< 0.1%

Value	Count	Frequency (%)
2017	11	0.1%
2016	198	2.0%
2015	306	3.1%
2014	437	4.4%
2013	518	5.2%
2012	568	5.7%
2011	556	5.6%
2010	473	4.7%
2009	432	4.3%
2008	383	3.8%

original_title
Text

Missing

Distinct	9274
Distinct (%)	98.5%
Missing	585
Missing (%)	5.9%
Memory size	783.5 KiB

Length

Max length	196
Median length	128
Mean length	22.997132
Min length	1

Characters and Unicode

Total characters	216518
Distinct characters	633
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9151 ?
Unique (%)	97.2%

Sample

1st row	The Hunger Games
2nd row	Harry Potter and the Philosopher's Stone
3rd row	Twilight
4th row	To Kill a Mockingbird
5th row	The Great Gatsby

Value	Count	Frequency (%)
the	4267	11.2%
of	1818	4.8%
a	854	2.2%
and	734	1.9%
in	450	1.2%
to	394	1.0%
for	212	0.6%
1	206	0.5%
you	179	0.5%
	166	0.4%
Other values (9532)	28905	75.7%

Most occurring characters

Value	Count	Frequency (%)
	29172	13.5%
e	21770	10.1%
o	12948	6.0%
a	11931	5.5%
n	11158	5.2%
r	11146	5.1%
i	11134	5.1%
t	10560	4.9%
s	8491	3.9%
h	8285	3.8%
Other values (623)	79923	36.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	216518	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	29172	13.5%
e	21770	10.1%
o	12948	6.0%
a	11931	5.5%
n	11158	5.2%
r	11146	5.1%
i	11134	5.1%
t	10560	4.9%
s	8491	3.9%
h	8285	3.8%
Other values (623)	79923	36.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	216518	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	29172	13.5%
e	21770	10.1%
o	12948	6.0%
a	11931	5.5%
n	11158	5.2%
r	11146	5.1%
i	11134	5.1%
t	10560	4.9%
s	8491	3.9%
h	8285	3.8%
Other values (623)	79923	36.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	216518	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	29172	13.5%
e	21770	10.1%
o	12948	6.0%
a	11931	5.5%
n	11158	5.2%
r	11146	5.1%
i	11134	5.1%
t	10560	4.9%
s	8491	3.9%
h	8285	3.8%
Other values (623)	79923	36.9%

title
Text

Distinct	9964
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	881.7 KiB

Length

Max length	186
Median length	120
Mean length	32.1462
Min length	2

Characters and Unicode

Total characters	321462
Distinct characters	198
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9931 ?
Unique (%)	99.3%

Sample

1st row	The Hunger Games (The Hunger Games, #1)
2nd row	Harry Potter and the Sorcerer's Stone (Harry Potter, #1)
3rd row	Twilight (Twilight, #1)
4th row	To Kill a Mockingbird
5th row	The Great Gatsby

Value	Count	Frequency (%)
the	5766	10.5%
of	2385	4.3%
1	1762	3.2%
a	976	1.8%
and	965	1.8%
2	878	1.6%
3	608	1.1%
in	562	1.0%
to	455	0.8%
4	327	0.6%
Other values (9713)	40308	73.3%

Most occurring characters

Value	Count	Frequency (%)
	45106	14.0%
e	29951	9.3%
o	17536	5.5%
a	16914	5.3%
r	15946	5.0%
n	15356	4.8%
i	15249	4.7%
t	13990	4.4%
s	11777	3.7%
h	11456	3.6%
Other values (188)	128181	39.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	321462	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	45106	14.0%
e	29951	9.3%
o	17536	5.5%
a	16914	5.3%
r	15946	5.0%
n	15356	4.8%
i	15249	4.7%
t	13990	4.4%
s	11777	3.7%
h	11456	3.6%
Other values (188)	128181	39.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	321462	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	45106	14.0%
e	29951	9.3%
o	17536	5.5%
a	16914	5.3%
r	15946	5.0%
n	15356	4.8%
i	15249	4.7%
t	13990	4.4%
s	11777	3.7%
h	11456	3.6%
Other values (188)	128181	39.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	321462	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	45106	14.0%
e	29951	9.3%
o	17536	5.5%
a	16914	5.3%
r	15946	5.0%
n	15356	4.8%
i	15249	4.7%
t	13990	4.4%
s	11777	3.7%
h	11456	3.6%
Other values (188)	128181	39.9%

language_code
Categorical

Imbalance Missing

Distinct	25
Distinct (%)	0.3%
Missing	1084
Missing (%)	10.8%
Memory size	586.5 KiB

eng	6341
en-US	2070
en-GB	257
ara	64
en-CA	58
Other values (20)	126

Length

Max length	5
Median length	3
Mean length	3.5344325
Min length	2

Characters and Unicode

Total characters	31513
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	0.1%

Sample

1st row	eng
2nd row	eng
3rd row	en-US
4th row	eng
5th row	eng

Common Values

Value	Count	Frequency (%)
eng	6341	63.4%
en-US	2070	20.7%
en-GB	257	2.6%
ara	64	0.6%
en-CA	58	0.6%
fre	25	0.2%
ind	21	0.2%
spa	20	0.2%
ger	13	0.1%
jpn	7	0.1%
Other values (15)	40	0.4%
(Missing)	1084	10.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
eng	6341	71.1%
en-us	2070	23.2%
en-gb	257	2.9%
ara	64	0.7%
en-ca	58	0.7%
fre	25	0.3%
ind	21	0.2%
spa	20	0.2%
ger	13	0.1%
jpn	7	0.1%
Other values (15)	40	0.4%

Most occurring characters

Value	Count	Frequency (%)
e	8777	27.9%
n	8765	27.8%
g	6354	20.2%
-	2385	7.6%
U	2070	6.6%
S	2070	6.6%
G	257	0.8%
B	257	0.8%
a	153	0.5%
r	121	0.4%
Other values (15)	304	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	31513	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	8777	27.9%
n	8765	27.8%
g	6354	20.2%
-	2385	7.6%
U	2070	6.6%
S	2070	6.6%
G	257	0.8%
B	257	0.8%
a	153	0.5%
r	121	0.4%
Other values (15)	304	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	31513	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	8777	27.9%
n	8765	27.8%
g	6354	20.2%
-	2385	7.6%
U	2070	6.6%
S	2070	6.6%
G	257	0.8%
B	257	0.8%
a	153	0.5%
r	121	0.4%
Other values (15)	304	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	31513	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	8777	27.9%
n	8765	27.8%
g	6354	20.2%
-	2385	7.6%
U	2070	6.6%
S	2070	6.6%
G	257	0.8%
B	257	0.8%
a	153	0.5%
r	121	0.4%
Other values (15)	304	1.0%

average_rating
Real number (ℝ)

Distinct	184
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.002191

Minimum	2.47
Maximum	4.82
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	2.47
5-th percentile	3.56
Q1	3.85
median	4.02
Q3	4.18
95-th percentile	4.38
Maximum	4.82
Range	2.35
Interquartile range (IQR)	0.33

Descriptive statistics

Standard deviation	0.25442748
Coefficient of variation (CV)	0.063572049
Kurtosis	0.88211881
Mean	4.002191
Median Absolute Deviation (MAD)	0.16
Skewness	-0.51161702
Sum	40021.91
Variance	0.064733343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.94	187	1.9%
3.98	180	1.8%
4.16	178	1.8%
4.07	173	1.7%
4.04	173	1.7%
4.12	172	1.7%
3.95	166	1.7%
4.14	165	1.7%
3.93	164	1.6%
4.11	164	1.6%
Other values (174)	8278	82.8%

Value	Count	Frequency (%)
2.47	1	< 0.1%
2.67	1	< 0.1%
2.76	1	< 0.1%
2.8	2	< 0.1%
2.84	3	< 0.1%
2.93	2	< 0.1%
2.96	1	< 0.1%
2.97	1	< 0.1%
2.98	1	< 0.1%
3	1	< 0.1%

Value	Count	Frequency (%)
4.82	1	< 0.1%
4.77	2	< 0.1%
4.76	2	< 0.1%
4.75	1	< 0.1%
4.74	2	< 0.1%
4.73	3	< 0.1%
4.72	2	< 0.1%
4.71	3	< 0.1%
4.68	1	< 0.1%
4.67	2	< 0.1%

ratings_count
Real number (ℝ)

High correlation

Distinct	9003
Distinct (%)	90.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54001.235

Minimum	2716
Maximum	4780653
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	2716
5-th percentile	9209.95
Q1	13568.75
median	21155.5
Q3	41053.5
95-th percentile	170454.9
Maximum	4780653
Range	4777937
Interquartile range (IQR)	27484.75

Descriptive statistics

Standard deviation	157369.96
Coefficient of variation (CV)	2.9141918
Kurtosis	258.7461
Mean	54001.235
Median Absolute Deviation (MAD)	9527.5
Skewness	13.058897
Sum	5.4001235 × 10⁸
Variance	2.4765303 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9081	5	0.1%
14860	4	< 0.1%
15362	4	< 0.1%
11985	4	< 0.1%
12510	4	< 0.1%
10729	4	< 0.1%
18655	3	< 0.1%
13562	3	< 0.1%
32490	3	< 0.1%
19210	3	< 0.1%
Other values (8993)	9963	99.6%

Value	Count	Frequency (%)
2716	1	< 0.1%
2773	1	< 0.1%
3200	1	< 0.1%
3427	1	< 0.1%
3508	1	< 0.1%
3799	1	< 0.1%
4225	1	< 0.1%
4281	1	< 0.1%
4513	1	< 0.1%
4528	1	< 0.1%

Value	Count	Frequency (%)
4780653	1	< 0.1%
4602479	1	< 0.1%
3866839	1	< 0.1%
3198671	1	< 0.1%
2683664	1	< 0.1%
2346404	1	< 0.1%
2071616	1	< 0.1%
2044241	1	< 0.1%
2035490	1	< 0.1%
2001311	1	< 0.1%

work_ratings_count
Real number (ℝ)

High correlation

Distinct	9053
Distinct (%)	90.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59687.322

Minimum	5510
Maximum	4942365
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	5510
5-th percentile	10880.9
Q1	15438.75
median	23832.5
Q3	45915
95-th percentile	187182.75
Maximum	4942365
Range	4936855
Interquartile range (IQR)	30476.25

Descriptive statistics

Standard deviation	167803.79
Coefficient of variation (CV)	2.8113807
Kurtosis	234.07198
Mean	59687.322
Median Absolute Deviation (MAD)	10450
Skewness	12.414522
Sum	5.9687322 × 10⁸
Variance	2.815811 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12882	5	0.1%
15443	4	< 0.1%
17018	4	< 0.1%
13975	4	< 0.1%
13740	4	< 0.1%
13787	4	< 0.1%
11472	4	< 0.1%
18509	3	< 0.1%
16847	3	< 0.1%
29204	3	< 0.1%
Other values (9043)	9962	99.6%

Value	Count	Frequency (%)
5510	1	< 0.1%
6323	1	< 0.1%
6823	1	< 0.1%
7045	1	< 0.1%
7353	1	< 0.1%
7410	1	< 0.1%
7437	1	< 0.1%
7735	1	< 0.1%
7825	1	< 0.1%
7845	1	< 0.1%

Value	Count	Frequency (%)
4942365	1	< 0.1%
4800065	1	< 0.1%
3916824	1	< 0.1%
3340896	1	< 0.1%
2773745	1	< 0.1%
2478609	1	< 0.1%
2216814	1	< 0.1%
2196809	1	< 0.1%
2191465	1	< 0.1%
2120637	1	< 0.1%

work_text_reviews_count
Real number (ℝ)

High correlation

Distinct	4581
Distinct (%)	45.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2919.9553

Minimum	3
Maximum	155254
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	3
5-th percentile	212
Q1	694
median	1402
Q3	2744.25
95-th percentile	9959.05
Maximum	155254
Range	155251
Interquartile range (IQR)	2050.25

Descriptive statistics

Standard deviation	6124.3781
Coefficient of variation (CV)	2.0974219
Kurtosis	134.04687
Mean	2919.9553
Median Absolute Deviation (MAD)	852
Skewness	9.130198
Sum	29199553
Variance	37508007
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
272	12	0.1%
1207	11	0.1%
330	11	0.1%
652	11	0.1%
575	10	0.1%
544	10	0.1%
584	10	0.1%
671	9	0.1%
767	9	0.1%
504	9	0.1%
Other values (4571)	9898	99.0%

Value	Count	Frequency (%)
3	1	< 0.1%
4	1	< 0.1%
11	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
24	2	< 0.1%
25	3	< 0.1%
26	1	< 0.1%
27	1	< 0.1%
28	2	< 0.1%

Value	Count	Frequency (%)
155254	1	< 0.1%
140739	1	< 0.1%
121614	1	< 0.1%
101023	1	< 0.1%
96274	1	< 0.1%
95009	1	< 0.1%
93611	1	< 0.1%
93600	1	< 0.1%
88538	1	< 0.1%
78204	1	< 0.1%

ratings_1
Real number (ℝ)

High correlation Skewed

Distinct	2630
Distinct (%)	26.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1345.0406

Minimum	11
Maximum	456191
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	11
5-th percentile	86
Q1	196
median	391
Q3	885
95-th percentile	4223.6
Maximum	456191
Range	456180
Interquartile range (IQR)	689

Descriptive statistics

Standard deviation	6635.6263
Coefficient of variation (CV)	4.9334022
Kurtosis	2289.6143
Mean	1345.0406
Median Absolute Deviation (MAD)	244
Skewness	37.711598
Sum	13450406
Variance	44031536
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
145	29	0.3%
197	27	0.3%
114	27	0.3%
121	27	0.3%
268	26	0.3%
149	26	0.3%
120	26	0.3%
186	25	0.2%
161	24	0.2%
243	24	0.2%
Other values (2620)	9739	97.4%

Value	Count	Frequency (%)
11	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	3	< 0.1%
20	3	< 0.1%
22	2	< 0.1%
23	1	< 0.1%

Value	Count	Frequency (%)
456191	1	< 0.1%
165455	1	< 0.1%
109383	1	< 0.1%
102837	1	< 0.1%
100994	1	< 0.1%
100373	1	< 0.1%
92779	1	< 0.1%
86236	1	< 0.1%
83094	1	< 0.1%
77841	1	< 0.1%

ratings_2
Real number (ℝ)

High correlation

Distinct	4117
Distinct (%)	41.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3110.885

Minimum	30
Maximum	436802
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	30
5-th percentile	315
Q1	656
median	1163
Q3	2353.25
95-th percentile	10416.9
Maximum	436802
Range	436772
Interquartile range (IQR)	1697.25

Descriptive statistics

Standard deviation	9717.1236
Coefficient of variation (CV)	3.1235882
Kurtosis	494.06574
Mean	3110.885
Median Absolute Deviation (MAD)	633.5
Skewness	16.492711
Sum	31108850
Variance	94422491
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
636	15	0.1%
600	13	0.1%
380	13	0.1%
581	13	0.1%
492	13	0.1%
770	12	0.1%
472	12	0.1%
496	12	0.1%
432	12	0.1%
658	12	0.1%
Other values (4107)	9873	98.7%

Value	Count	Frequency (%)
30	1	< 0.1%
40	1	< 0.1%
53	1	< 0.1%
57	1	< 0.1%
61	2	< 0.1%
62	1	< 0.1%
66	1	< 0.1%
69	1	< 0.1%
77	1	< 0.1%
83	1	< 0.1%

Value	Count	Frequency (%)
436802	1	< 0.1%
197621	1	< 0.1%
185520	1	< 0.1%
160660	1	< 0.1%
160295	1	< 0.1%
153179	1	< 0.1%
152293	1	< 0.1%
149549	1	< 0.1%
145740	1	< 0.1%
135147	1	< 0.1%

ratings_3
Real number (ℝ)

High correlation

Distinct	6972
Distinct (%)	69.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11475.894

Minimum	323
Maximum	793319
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	323
5-th percentile	1774.95
Q1	3112
median	4894
Q3	9287
95-th percentile	37298.5
Maximum	793319
Range	792996
Interquartile range (IQR)	6175

Descriptive statistics

Standard deviation	28546.449
Coefficient of variation (CV)	2.4875142
Kurtosis	160.8281
Mean	11475.894
Median Absolute Deviation (MAD)	2260
Skewness	10.399466
Sum	1.1475894 × 10⁸
Variance	8.1489976 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3200	8	0.1%
3016	6	0.1%
4518	6	0.1%
2643	6	0.1%
3704	6	0.1%
2593	6	0.1%
3261	6	0.1%
4059	6	0.1%
2442	6	0.1%
3876	6	0.1%
Other values (6962)	9938	99.4%

Value	Count	Frequency (%)
323	1	< 0.1%
367	1	< 0.1%
384	1	< 0.1%
408	1	< 0.1%
463	1	< 0.1%
514	1	< 0.1%
570	1	< 0.1%
589	1	< 0.1%
638	1	< 0.1%
666	1	< 0.1%

Value	Count	Frequency (%)
793319	1	< 0.1%
606158	1	< 0.1%
560092	1	< 0.1%
458429	1	< 0.1%
455042	1	< 0.1%
455024	1	< 0.1%
452673	1	< 0.1%
446835	1	< 0.1%
433432	1	< 0.1%
425648	1	< 0.1%

ratings_4
Real number (ℝ)

High correlation

Distinct	7762
Distinct (%)	77.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19965.697

Minimum	750
Maximum	1481305
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	750
5-th percentile	3449.85
Q1	5405.75
median	8269.5
Q3	16023.5
95-th percentile	63914.8
Maximum	1481305
Range	1480555
Interquartile range (IQR)	10617.75

Descriptive statistics

Standard deviation	51447.358
Coefficient of variation (CV)	2.5767875
Kurtosis	174.02564
Mean	19965.697
Median Absolute Deviation (MAD)	3675
Skewness	10.806903
Sum	1.9965697 × 10⁸
Variance	2.6468307 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5070	6	0.1%
5692	6	0.1%
6277	6	0.1%
6749	6	0.1%
3894	6	0.1%
6382	5	0.1%
5376	5	0.1%
7936	5	0.1%
7489	5	0.1%
5308	5	0.1%
Other values (7752)	9945	99.5%

Value	Count	Frequency (%)
750	1	< 0.1%
872	1	< 0.1%
891	1	< 0.1%
1107	1	< 0.1%
1152	1	< 0.1%
1363	1	< 0.1%
1365	1	< 0.1%
1381	1	< 0.1%
1435	1	< 0.1%
1519	1	< 0.1%

Value	Count	Frequency (%)
1481305	1	< 0.1%
1156318	1	< 0.1%
1001952	1	< 0.1%
936012	1	< 0.1%
875073	1	< 0.1%
716569	1	< 0.1%
698642	1	< 0.1%
698471	1	< 0.1%
692021	1	< 0.1%
687238	1	< 0.1%

ratings_5
Real number (ℝ)

High correlation

Distinct	8103
Distinct (%)	81.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23789.806

Minimum	754
Maximum	3011543
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	754
5-th percentile	2939.95
Q1	5334
median	8836
Q3	17304.5
95-th percentile	74148.8
Maximum	3011543
Range	3010789
Interquartile range (IQR)	11970.5

Descriptive statistics

Standard deviation	79768.886
Coefficient of variation (CV)	3.3530701
Kurtosis	419.88093
Mean	23789.806
Median Absolute Deviation (MAD)	4397.5
Skewness	16.373531
Sum	2.3789806 × 10⁸
Variance	6.3630751 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4541	6	0.1%
5542	5	0.1%
4525	5	0.1%
6061	5	0.1%
4488	5	0.1%
5653	5	0.1%
4901	5	0.1%
5475	5	0.1%
3604	5	0.1%
4314	5	0.1%
Other values (8093)	9949	99.5%

Value	Count	Frequency (%)
754	1	< 0.1%
781	1	< 0.1%
788	1	< 0.1%
849	1	< 0.1%
862	1	< 0.1%
885	1	< 0.1%
1001	1	< 0.1%
1030	1	< 0.1%
1056	1	< 0.1%
1076	1	< 0.1%

Value	Count	Frequency (%)
3011543	1	< 0.1%
2706317	1	< 0.1%
1714267	1	< 0.1%
1355439	1	< 0.1%
1318227	1	< 0.1%
1311871	1	< 0.1%
1266670	1	< 0.1%
1195045	1	< 0.1%
1161491	1	< 0.1%
1155673	1	< 0.1%

image_url
URL

Distinct	6669
Distinct (%)	66.7%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png	3332
https://images.gr-assets.com/books/1494428973m/43641.jpg	1
https://images.gr-assets.com/books/1421696237m/17901125.jpg	1
https://images.gr-assets.com/books/1329259095m/263173.jpg	1
https://images.gr-assets.com/books/1387141547m/2.jpg	1
Other values (6664)	6664

Value	Count	Frequency (%)
https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png	3332	33.3%
https://images.gr-assets.com/books/1494428973m/43641.jpg	1	< 0.1%
https://images.gr-assets.com/books/1421696237m/17901125.jpg	1	< 0.1%
https://images.gr-assets.com/books/1329259095m/263173.jpg	1	< 0.1%
https://images.gr-assets.com/books/1387141547m/2.jpg	1	< 0.1%
https://images.gr-assets.com/books/1403194704m/8914.jpg	1	< 0.1%
https://images.gr-assets.com/books/1447303603m/2767052.jpg	1	< 0.1%
https://images.gr-assets.com/books/1474154022m/3.jpg	1	< 0.1%
https://images.gr-assets.com/books/1361039443m/41865.jpg	1	< 0.1%
https://images.gr-assets.com/books/1361975680m/2657.jpg	1	< 0.1%
Other values (6659)	6659	66.6%

Value	Count	Frequency (%)
https	10000	100.0%

Value	Count	Frequency (%)
images.gr-assets.com	6668	66.7%
s.gr-assets.com	3332	33.3%

Value	Count	Frequency (%)
/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png	3332	33.3%
/books/1494428973m/43641.jpg	1	< 0.1%
/books/1421696237m/17901125.jpg	1	< 0.1%
/books/1329259095m/263173.jpg	1	< 0.1%
/books/1387141547m/2.jpg	1	< 0.1%
/books/1403194704m/8914.jpg	1	< 0.1%
/books/1447303603m/2767052.jpg	1	< 0.1%
/books/1474154022m/3.jpg	1	< 0.1%
/books/1361039443m/41865.jpg	1	< 0.1%
/books/1361975680m/2657.jpg	1	< 0.1%
Other values (6659)	6659	66.6%

Value	Count	Frequency (%)
	10000	100.0%

Value	Count	Frequency (%)
	10000	100.0%

small_image_url
URL

Distinct	6669
Distinct (%)	66.7%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

https://s.gr-assets.com/assets/nophoto/book/50x75-a91bf249278a81aabab721ef782c4a74.png	3332
https://images.gr-assets.com/books/1494428973s/43641.jpg	1
https://images.gr-assets.com/books/1421696237s/17901125.jpg	1
https://images.gr-assets.com/books/1329259095s/263173.jpg	1
https://images.gr-assets.com/books/1387141547s/2.jpg	1
Other values (6664)	6664

Value	Count	Frequency (%)
https://s.gr-assets.com/assets/nophoto/book/50x75-a91bf249278a81aabab721ef782c4a74.png	3332	33.3%
https://images.gr-assets.com/books/1494428973s/43641.jpg	1	< 0.1%
https://images.gr-assets.com/books/1421696237s/17901125.jpg	1	< 0.1%
https://images.gr-assets.com/books/1329259095s/263173.jpg	1	< 0.1%
https://images.gr-assets.com/books/1387141547s/2.jpg	1	< 0.1%
https://images.gr-assets.com/books/1403194704s/8914.jpg	1	< 0.1%
https://images.gr-assets.com/books/1447303603s/2767052.jpg	1	< 0.1%
https://images.gr-assets.com/books/1474154022s/3.jpg	1	< 0.1%
https://images.gr-assets.com/books/1361039443s/41865.jpg	1	< 0.1%
https://images.gr-assets.com/books/1361975680s/2657.jpg	1	< 0.1%
Other values (6659)	6659	66.6%

Value	Count	Frequency (%)
https	10000	100.0%

Value	Count	Frequency (%)
images.gr-assets.com	6668	66.7%
s.gr-assets.com	3332	33.3%

Value	Count	Frequency (%)
/assets/nophoto/book/50x75-a91bf249278a81aabab721ef782c4a74.png	3332	33.3%
/books/1494428973s/43641.jpg	1	< 0.1%
/books/1421696237s/17901125.jpg	1	< 0.1%
/books/1329259095s/263173.jpg	1	< 0.1%
/books/1387141547s/2.jpg	1	< 0.1%
/books/1403194704s/8914.jpg	1	< 0.1%
/books/1447303603s/2767052.jpg	1	< 0.1%
/books/1474154022s/3.jpg	1	< 0.1%
/books/1361039443s/41865.jpg	1	< 0.1%
/books/1361975680s/2657.jpg	1	< 0.1%
Other values (6659)	6659	66.6%

Value	Count	Frequency (%)
	10000	100.0%

Value	Count	Frequency (%)
	10000	100.0%

Interactions

Correlations

	average_rating	best_book_id	book_id	books_count	goodreads_book_id	isbn13	language_code	original_publication_year	ratings_1	ratings_2	ratings_3	ratings_4	ratings_5	ratings_count	work_id	work_ratings_count	work_text_reviews_count
average_rating	1.000	0.042	-0.036	-0.184	0.040	0.103	0.030	-0.027	-0.357	-0.470	-0.330	0.014	0.411	0.079	-0.035	0.065	-0.151
best_book_id	0.042	1.000	0.170	-0.389	0.981	0.126	0.076	0.775	-0.025	-0.100	-0.151	-0.098	-0.090	-0.149	0.724	-0.100	0.254
book_id	-0.036	0.170	1.000	-0.458	0.180	0.045	0.021	0.109	-0.716	-0.762	-0.859	-0.918	-0.857	-0.937	0.051	-0.950	-0.605
books_count	-0.184	-0.389	-0.458	1.000	-0.401	-0.151	0.000	-0.433	0.310	0.437	0.512	0.477	0.307	0.393	-0.224	0.435	0.282
goodreads_book_id	0.040	0.981	0.180	-0.401	1.000	0.128	0.080	0.788	-0.033	-0.109	-0.160	-0.108	-0.099	-0.154	0.735	-0.110	0.247
isbn13	0.103	0.126	0.045	-0.151	0.128	1.000	0.110	0.105	-0.031	-0.086	-0.114	-0.079	-0.009	-0.064	0.073	-0.061	-0.045
language_code	0.030	0.076	0.021	0.000	0.080	0.110	1.000	0.095	0.000	0.000	0.000	0.000	0.000	0.000	0.069	0.000	0.000
original_publication_year	-0.027	0.775	0.109	-0.433	0.788	0.105	0.095	1.000	0.024	-0.026	-0.070	-0.012	-0.066	-0.074	0.723	-0.034	0.376
ratings_1	-0.357	-0.025	-0.716	0.310	-0.033	-0.031	0.000	0.024	1.000	0.924	0.783	0.637	0.545	0.701	0.070	0.707	0.630
ratings_2	-0.470	-0.100	-0.762	0.437	-0.109	-0.086	0.000	-0.026	0.924	1.000	0.927	0.740	0.534	0.759	0.031	0.773	0.657
ratings_3	-0.330	-0.151	-0.859	0.512	-0.160	-0.114	0.000	-0.070	0.783	0.927	1.000	0.894	0.656	0.872	-0.007	0.890	0.655
ratings_4	0.014	-0.098	-0.918	0.477	-0.108	-0.079	0.000	-0.012	0.637	0.740	0.894	1.000	0.845	0.940	0.042	0.969	0.702
ratings_5	0.411	-0.090	-0.857	0.307	-0.099	-0.009	0.000	-0.066	0.545	0.534	0.656	0.845	1.000	0.905	-0.013	0.908	0.524
ratings_count	0.079	-0.149	-0.937	0.393	-0.154	-0.064	0.000	-0.074	0.701	0.759	0.872	0.940	0.905	1.000	-0.030	0.982	0.613
work_id	-0.035	0.724	0.051	-0.224	0.735	0.073	0.069	0.723	0.070	0.031	-0.007	0.042	-0.013	-0.030	1.000	0.023	0.365
work_ratings_count	0.065	-0.100	-0.950	0.435	-0.110	-0.061	0.000	-0.034	0.707	0.773	0.890	0.969	0.908	0.982	0.023	1.000	0.671
work_text_reviews_count	-0.151	0.254	-0.605	0.282	0.247	-0.045	0.000	0.376	0.630	0.657	0.655	0.702	0.524	0.613	0.365	0.671	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	book_id	goodreads_book_id	best_book_id	work_id	books_count	isbn	isbn13	authors	original_publication_year	original_title	title	language_code	average_rating	ratings_count	work_ratings_count	work_text_reviews_count	ratings_1	ratings_2	ratings_3	ratings_4	ratings_5	image_url	small_image_url
0	1	2767052	2767052	2792775	272	439023483	9.780439e+12	Suzanne Collins	2008.0	The Hunger Games	The Hunger Games (The Hunger Games, #1)	eng	4.34	4780653	4942365	155254	66715	127936	560092	1481305	2706317	https://images.gr-assets.com/books/1447303603m/2767052.jpg	https://images.gr-assets.com/books/1447303603s/2767052.jpg
1	2	3	3	4640799	491	439554934	9.780440e+12	J.K. Rowling, Mary GrandPré	1997.0	Harry Potter and the Philosopher's Stone	Harry Potter and the Sorcerer's Stone (Harry Potter, #1)	eng	4.44	4602479	4800065	75867	75504	101676	455024	1156318	3011543	https://images.gr-assets.com/books/1474154022m/3.jpg	https://images.gr-assets.com/books/1474154022s/3.jpg
2	3	41865	41865	3212258	226	316015849	9.780316e+12	Stephenie Meyer	2005.0	Twilight	Twilight (Twilight, #1)	en-US	3.57	3866839	3916824	95009	456191	436802	793319	875073	1355439	https://images.gr-assets.com/books/1361039443m/41865.jpg	https://images.gr-assets.com/books/1361039443s/41865.jpg
3	4	2657	2657	3275794	487	61120081	9.780061e+12	Harper Lee	1960.0	To Kill a Mockingbird	To Kill a Mockingbird	eng	4.25	3198671	3340896	72586	60427	117415	446835	1001952	1714267	https://images.gr-assets.com/books/1361975680m/2657.jpg	https://images.gr-assets.com/books/1361975680s/2657.jpg
4	5	4671	4671	245494	1356	743273567	9.780743e+12	F. Scott Fitzgerald	1925.0	The Great Gatsby	The Great Gatsby	eng	3.89	2683664	2773745	51992	86236	197621	606158	936012	947718	https://images.gr-assets.com/books/1490528560m/4671.jpg	https://images.gr-assets.com/books/1490528560s/4671.jpg
5	6	11870085	11870085	16827462	226	525478817	9.780525e+12	John Green	2012.0	The Fault in Our Stars	The Fault in Our Stars	eng	4.26	2346404	2478609	140739	47994	92723	327550	698471	1311871	https://images.gr-assets.com/books/1360206420m/11870085.jpg	https://images.gr-assets.com/books/1360206420s/11870085.jpg
6	7	5907	5907	1540236	969	618260307	9.780618e+12	J.R.R. Tolkien	1937.0	The Hobbit or There and Back Again	The Hobbit	en-US	4.25	2071616	2196809	37653	46023	76784	288649	665635	1119718	https://images.gr-assets.com/books/1372847500m/5907.jpg	https://images.gr-assets.com/books/1372847500s/5907.jpg
7	8	5107	5107	3036731	360	316769177	9.780317e+12	J.D. Salinger	1951.0	The Catcher in the Rye	The Catcher in the Rye	eng	3.79	2044241	2120637	44920	109383	185520	455042	661516	709176	https://images.gr-assets.com/books/1398034300m/5107.jpg	https://images.gr-assets.com/books/1398034300s/5107.jpg
8	9	960	960	3338963	311	1416524797	9.781417e+12	Dan Brown	2000.0	Angels & Demons	Angels & Demons (Robert Langdon, #1)	en-CA	3.85	2001311	2078754	25112	77841	145740	458429	716569	680175	https://images.gr-assets.com/books/1303390735m/960.jpg	https://images.gr-assets.com/books/1303390735s/960.jpg
9	10	1885	1885	3060926	3455	679783261	9.780680e+12	Jane Austen	1813.0	Pride and Prejudice	Pride and Prejudice	eng	4.24	2035490	2191465	49152	54700	86485	284852	609755	1155673	https://images.gr-assets.com/books/1320399351m/1885.jpg	https://images.gr-assets.com/books/1320399351s/1885.jpg

	book_id	goodreads_book_id	best_book_id	work_id	books_count	isbn	isbn13	authors	original_publication_year	original_title	title	language_code	average_rating	ratings_count	work_ratings_count	work_text_reviews_count	ratings_1	ratings_2	ratings_3	ratings_4	ratings_5	image_url	small_image_url
9990	9991	101094	101094	1198275	37	385425139	9.780385e+12	Ben Okri	1991.0	The Famished Road	The Famished Road	eng	3.73	8251	8875	586	465	815	2046	2895	2654	https://images.gr-assets.com/books/1344396715m/101094.jpg	https://images.gr-assets.com/books/1344396715s/101094.jpg
9991	9992	13616278	13616278	19217996	26	575113294	9.780575e+12	Miles Cameron	2012.0	The Red Knight	The Red Knight (The Traitor Son Cycle, #1)	eng	4.12	8556	10102	742	232	491	1375	3712	4292	https://images.gr-assets.com/books/1348037761m/13616278.jpg	https://images.gr-assets.com/books/1348037761s/13616278.jpg
9992	9993	4936457	4936457	5002120	27	224079948	9.780224e+12	Ian Mortimer	2008.0	The Time-Traveller's Guide to Medieval England: A Handbook for Visitors to the Fourteenth Century	The Time Traveller's Guide to Medieval England: A Handbook for Visitors to the Fourteenth Century	eng	3.99	9824	12115	970	236	521	2497	4790	4071	https://images.gr-assets.com/books/1328167619m/4936457.jpg	https://images.gr-assets.com/books/1328167619s/4936457.jpg
9993	9994	4769651	4769651	4834466	2	810983559	9.780811e+12	Michael Buckley, Peter Ferguson	2009.0	The Everafter War (The Sisters Grimm, #7)	The Everafter War (The Sisters Grimm, #7)	eng	4.32	12493	12965	455	110	289	1745	3989	6832	https://images.gr-assets.com/books/1388278230m/4769651.jpg	https://images.gr-assets.com/books/1388278230s/4769651.jpg
9994	9995	15613	15613	2764239	199	1416523723	9.781417e+12	Herman Melville	1924.0	Billy Budd, Sailor	Billy Budd, Sailor	eng	3.09	10866	12110	681	1478	2225	3805	2985	1617	https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png	https://s.gr-assets.com/assets/nophoto/book/50x75-a91bf249278a81aabab721ef782c4a74.png
9995	9996	7130616	7130616	7392860	19	441019455	9.780441e+12	Ilona Andrews	2010.0	Bayou Moon	Bayou Moon (The Edge, #2)	eng	4.09	17204	18856	1180	105	575	3538	7860	6778	https://images.gr-assets.com/books/1307445460m/7130616.jpg	https://images.gr-assets.com/books/1307445460s/7130616.jpg
9996	9997	208324	208324	1084709	19	067973371X	9.780680e+12	Robert A. Caro	1990.0	Means of Ascent	Means of Ascent (The Years of Lyndon Johnson, #2)	eng	4.25	12582	12952	395	303	551	1737	3389	6972	https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png	https://s.gr-assets.com/assets/nophoto/book/50x75-a91bf249278a81aabab721ef782c4a74.png
9997	9998	77431	77431	2393986	60	039330762X	9.780393e+12	Patrick O'Brian	1977.0	The Mauritius Command	The Mauritius Command	eng	4.35	9421	10733	374	11	111	1191	4240	5180	https://images.gr-assets.com/books/1455373531m/77431.jpg	https://images.gr-assets.com/books/1455373531s/77431.jpg
9998	9999	8565083	8565083	13433613	7	61711527	9.780062e+12	Peggy Orenstein	2011.0	Cinderella Ate My Daughter: Dispatches from the Frontlines of the New Girlie-Girl Culture	Cinderella Ate My Daughter: Dispatches from the Frontlines of the New Girlie-Girl Culture	eng	3.65	11279	11994	1988	275	1002	3765	4577	2375	https://images.gr-assets.com/books/1279214118m/8565083.jpg	https://images.gr-assets.com/books/1279214118s/8565083.jpg
9999	10000	8914	8914	11817	31	375700455	9.780376e+12	John Keegan	1998.0	The First World War	The First World War	NaN	4.00	9162	9700	364	117	345	2031	4138	3069	https://images.gr-assets.com/books/1403194704m/8914.jpg	https://images.gr-assets.com/books/1403194704s/8914.jpg

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample